Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 1070 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 159.0 KiB |
| Average record size in memory | 152.1 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 5 |
| Boolean | 1 |
WeekofPurchase is highly overall correlated with PriceCH and 9 other fields | High correlation |
PriceCH is highly overall correlated with WeekofPurchase and 13 other fields | High correlation |
PriceMM is highly overall correlated with WeekofPurchase and 12 other fields | High correlation |
DiscCH is highly overall correlated with WeekofPurchase and 8 other fields | High correlation |
DiscMM is highly overall correlated with WeekofPurchase and 8 other fields | High correlation |
LoyalCH is highly overall correlated with Id and 3 other fields | High correlation |
SalePriceMM is highly overall correlated with WeekofPurchase and 12 other fields | High correlation |
SalePriceCH is highly overall correlated with WeekofPurchase and 13 other fields | High correlation |
PriceDiff is highly overall correlated with WeekofPurchase and 11 other fields | High correlation |
PctDiscMM is highly overall correlated with WeekofPurchase and 11 other fields | High correlation |
PctDiscCH is highly overall correlated with WeekofPurchase and 8 other fields | High correlation |
ListPriceDiff is highly overall correlated with WeekofPurchase and 11 other fields | High correlation |
Purchase is highly overall correlated with LoyalCH | High correlation |
StoreID is highly overall correlated with Id and 9 other fields | High correlation |
SpecialCH is highly overall correlated with DiscCH and 5 other fields | High correlation |
SpecialMM is highly overall correlated with PriceCH and 4 other fields | High correlation |
Store7 is highly overall correlated with StoreID and 9 other fields | High correlation |
STORE is highly overall correlated with Id and 9 other fields | High correlation |
Id is highly overall correlated with StoreID and 2 other fields | High correlation |
Id is uniformly distributed | Uniform |
Id has unique values | Unique |
DiscCH has 838 (78.3%) zeros | Zeros |
DiscMM has 746 (69.7%) zeros | Zeros |
PriceDiff has 75 (7.0%) zeros | Zeros |
PctDiscMM has 746 (69.7%) zeros | Zeros |
PctDiscCH has 838 (78.3%) zeros | Zeros |
ListPriceDiff has 119 (11.1%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-24 14:53:36.198993 |
|---|---|
| Analysis finished | 2022-11-24 14:54:09.143449 |
| Duration | 32.94 seconds |
| Software version | pandas-profiling vv3.5.0 |
| Download configuration | config.json |
| Distinct | 1070 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 535.5 |
| Minimum | 1 |
|---|---|
| Maximum | 1070 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 54.45 |
| Q1 | 268.25 |
| median | 535.5 |
| Q3 | 802.75 |
| 95-th percentile | 1016.55 |
| Maximum | 1070 |
| Range | 1069 |
| Interquartile range (IQR) | 534.5 |
Descriptive statistics
| Standard deviation | 309.0267 |
|---|---|
| Coefficient of variation (CV) | 0.57708067 |
| Kurtosis | -1.2 |
| Mean | 535.5 |
| Median Absolute Deviation (MAD) | 267.5 |
| Skewness | 0 |
| Sum | 572985 |
| Variance | 95497.5 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | 0.1% |
| 719 | 1 | 0.1% |
| 705 | 1 | 0.1% |
| 706 | 1 | 0.1% |
| 707 | 1 | 0.1% |
| 708 | 1 | 0.1% |
| 709 | 1 | 0.1% |
| 710 | 1 | 0.1% |
| 711 | 1 | 0.1% |
| 712 | 1 | 0.1% |
| Other values (1060) | 1060 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 1070 | 1 | |
| 1069 | 1 | |
| 1068 | 1 | |
| 1067 | 1 | |
| 1066 | 1 | |
| 1065 | 1 | |
| 1064 | 1 | |
| 1063 | 1 | |
| 1062 | 1 | |
| 1061 | 1 |
Purchase
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 KiB |
| CH | |
|---|---|
| MM |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2140 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CH |
|---|---|
| 2nd row | CH |
| 3rd row | CH |
| 4th row | MM |
| 5th row | CH |
Common Values
| Value | Count | Frequency (%) |
| CH | 653 | |
| MM | 417 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ch | 653 | |
| mm | 417 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 834 | |
| C | 653 | |
| H | 653 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2140 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 834 | |
| C | 653 | |
| H | 653 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2140 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 834 | |
| C | 653 | |
| H | 653 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2140 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 834 | |
| C | 653 | |
| H | 653 |
WeekofPurchase
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 254.38131 |
| Minimum | 227 |
|---|---|
| Maximum | 278 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 227 |
|---|---|
| 5-th percentile | 229 |
| Q1 | 240 |
| median | 257 |
| Q3 | 268 |
| 95-th percentile | 276 |
| Maximum | 278 |
| Range | 51 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.558286 |
|---|---|
| Coefficient of variation (CV) | 0.061161279 |
| Kurtosis | -1.2749267 |
| Mean | 254.38131 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.21098982 |
| Sum | 272188 |
| Variance | 242.06027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 274 | 39 | 3.6% |
| 275 | 33 | 3.1% |
| 269 | 32 | 3.0% |
| 259 | 31 | 2.9% |
| 260 | 29 | 2.7% |
| 233 | 28 | 2.6% |
| 267 | 26 | 2.4% |
| 266 | 26 | 2.4% |
| 256 | 26 | 2.4% |
| 265 | 26 | 2.4% |
| Other values (42) | 774 |
| Value | Count | Frequency (%) |
| 227 | 15 | |
| 228 | 22 | |
| 229 | 23 | |
| 230 | 19 | |
| 231 | 20 | |
| 232 | 19 | |
| 233 | 28 | |
| 234 | 18 | |
| 235 | 16 | |
| 236 | 23 |
| Value | Count | Frequency (%) |
| 278 | 18 | |
| 277 | 25 | |
| 276 | 26 | |
| 275 | 33 | |
| 274 | 39 | |
| 273 | 19 | |
| 272 | 25 | |
| 271 | 20 | |
| 270 | 23 | |
| 269 | 32 |
StoreID
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 KiB |
| 7 | |
|---|---|
| 2 | |
| 3 | |
| 1 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1070 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 7 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 7 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1070 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1070 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 7 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1070 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
PriceCH
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8674206 |
| Minimum | 1.69 |
|---|---|
| Maximum | 2.09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 1.69 |
|---|---|
| 5-th percentile | 1.69 |
| Q1 | 1.79 |
| median | 1.86 |
| Q3 | 1.99 |
| 95-th percentile | 1.99 |
| Maximum | 2.09 |
| Range | 0.4 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.10196975 |
|---|---|
| Coefficient of variation (CV) | 0.0546046 |
| Kurtosis | -0.77513258 |
| Mean | 1.8674206 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 0.064415883 |
| Sum | 1998.14 |
| Variance | 0.01039783 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.86 | 376 | |
| 1.99 | 259 | |
| 1.79 | 101 | 9.4% |
| 1.75 | 95 | 8.9% |
| 1.69 | 94 | 8.8% |
| 1.89 | 42 | 3.9% |
| 1.76 | 40 | 3.7% |
| 1.96 | 29 | 2.7% |
| 2.09 | 27 | 2.5% |
| 2.06 | 7 | 0.7% |
| Value | Count | Frequency (%) |
| 1.69 | 94 | 8.8% |
| 1.75 | 95 | 8.9% |
| 1.76 | 40 | 3.7% |
| 1.79 | 101 | 9.4% |
| 1.86 | 376 | |
| 1.89 | 42 | 3.9% |
| 1.96 | 29 | 2.7% |
| 1.99 | 259 | |
| 2.06 | 7 | 0.7% |
| 2.09 | 27 | 2.5% |
| Value | Count | Frequency (%) |
| 2.09 | 27 | 2.5% |
| 2.06 | 7 | 0.7% |
| 1.99 | 259 | |
| 1.96 | 29 | 2.7% |
| 1.89 | 42 | 3.9% |
| 1.86 | 376 | |
| 1.79 | 101 | 9.4% |
| 1.76 | 40 | 3.7% |
| 1.75 | 95 | 8.9% |
| 1.69 | 94 | 8.8% |
PriceMM
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0854112 |
| Minimum | 1.69 |
|---|---|
| Maximum | 2.29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 1.69 |
|---|---|
| 5-th percentile | 1.69 |
| Q1 | 1.99 |
| median | 2.09 |
| Q3 | 2.18 |
| 95-th percentile | 2.23 |
| Maximum | 2.29 |
| Range | 0.6 |
| Interquartile range (IQR) | 0.19 |
Descriptive statistics
| Standard deviation | 0.13438551 |
|---|---|
| Coefficient of variation (CV) | 0.064440774 |
| Kurtosis | 2.1839215 |
| Mean | 2.0854112 |
| Median Absolute Deviation (MAD) | 0.09 |
| Skewness | -1.4618508 |
| Sum | 2231.39 |
| Variance | 0.018059466 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.09 | 273 | |
| 2.18 | 201 | |
| 2.13 | 197 | |
| 1.99 | 179 | |
| 2.23 | 88 | 8.2% |
| 1.69 | 57 | 5.3% |
| 2.29 | 40 | 3.7% |
| 1.79 | 35 | 3.3% |
| Value | Count | Frequency (%) |
| 1.69 | 57 | 5.3% |
| 1.79 | 35 | 3.3% |
| 1.99 | 179 | |
| 2.09 | 273 | |
| 2.13 | 197 | |
| 2.18 | 201 | |
| 2.23 | 88 | 8.2% |
| 2.29 | 40 | 3.7% |
| Value | Count | Frequency (%) |
| 2.29 | 40 | 3.7% |
| 2.23 | 88 | 8.2% |
| 2.18 | 201 | |
| 2.13 | 197 | |
| 2.09 | 273 | |
| 1.99 | 179 | |
| 1.79 | 35 | 3.3% |
| 1.69 | 57 | 5.3% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.051859813 |
| Minimum | 0 |
|---|---|
| Maximum | 0.5 |
| Zeros | 838 |
| Zeros (%) | 78.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.37 |
| Maximum | 0.5 |
| Range | 0.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.11747419 |
|---|---|
| Coefficient of variation (CV) | 2.2652259 |
| Kurtosis | 4.9336362 |
| Mean | 0.051859813 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.4163405 |
| Sum | 55.49 |
| Variance | 0.013800186 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 838 | |
| 0.1 | 74 | 6.9% |
| 0.37 | 36 | 3.4% |
| 0.27 | 29 | 2.7% |
| 0.47 | 21 | 2.0% |
| 0.2 | 21 | 2.0% |
| 0.13 | 21 | 2.0% |
| 0.5 | 12 | 1.1% |
| 0.3 | 6 | 0.6% |
| 0.24 | 5 | 0.5% |
| Other values (2) | 7 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 838 | |
| 0.1 | 74 | 6.9% |
| 0.13 | 21 | 2.0% |
| 0.16 | 5 | 0.5% |
| 0.17 | 2 | 0.2% |
| 0.2 | 21 | 2.0% |
| 0.24 | 5 | 0.5% |
| 0.27 | 29 | 2.7% |
| 0.3 | 6 | 0.6% |
| 0.37 | 36 | 3.4% |
| Value | Count | Frequency (%) |
| 0.5 | 12 | 1.1% |
| 0.47 | 21 | |
| 0.37 | 36 | |
| 0.3 | 6 | 0.6% |
| 0.27 | 29 | |
| 0.24 | 5 | 0.5% |
| 0.2 | 21 | |
| 0.17 | 2 | 0.2% |
| 0.16 | 5 | 0.5% |
| 0.13 | 21 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12336449 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 746 |
| Zeros (%) | 69.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.23 |
| 95-th percentile | 0.54 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.23 |
Descriptive statistics
| Standard deviation | 0.21383375 |
|---|---|
| Coefficient of variation (CV) | 1.7333493 |
| Kurtosis | 1.4920999 |
| Mean | 0.12336449 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.5947836 |
| Sum | 132 |
| Variance | 0.045724872 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 746 | |
| 0.4 | 132 | 12.3% |
| 0.54 | 42 | 3.9% |
| 0.2 | 32 | 3.0% |
| 0.3 | 29 | 2.7% |
| 0.8 | 26 | 2.4% |
| 0.24 | 18 | 1.7% |
| 0.06 | 15 | 1.4% |
| 0.74 | 10 | 0.9% |
| 0.1 | 9 | 0.8% |
| Other values (2) | 11 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 746 | |
| 0.06 | 15 | 1.4% |
| 0.1 | 9 | 0.8% |
| 0.2 | 32 | 3.0% |
| 0.24 | 18 | 1.7% |
| 0.3 | 29 | 2.7% |
| 0.4 | 132 | 12.3% |
| 0.54 | 42 | 3.9% |
| 0.6 | 6 | 0.6% |
| 0.7 | 5 | 0.5% |
| Value | Count | Frequency (%) |
| 0.8 | 26 | 2.4% |
| 0.74 | 10 | 0.9% |
| 0.7 | 5 | 0.5% |
| 0.6 | 6 | 0.6% |
| 0.54 | 42 | 3.9% |
| 0.4 | 132 | |
| 0.3 | 29 | 2.7% |
| 0.24 | 18 | 1.7% |
| 0.2 | 32 | 3.0% |
| 0.1 | 9 | 0.8% |
SpecialCH
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1070 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 912 | |
| 1 | 158 | 14.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 912 | |
| 1 | 158 | 14.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 912 | |
| 1 | 158 | 14.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1070 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 912 | |
| 1 | 158 | 14.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1070 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 912 | |
| 1 | 158 | 14.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1070 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 912 | |
| 1 | 158 | 14.8% |
SpecialMM
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1070 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 897 | |
| 1 | 173 | 16.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 897 | |
| 1 | 173 | 16.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 897 | |
| 1 | 173 | 16.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1070 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 897 | |
| 1 | 173 | 16.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1070 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 897 | |
| 1 | 173 | 16.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1070 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 897 | |
| 1 | 173 | 16.2% |
LoyalCH
Real number (ℝ)
| Distinct | 553 |
|---|---|
| Distinct (%) | 51.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.56578233 |
| Minimum | 1.1 × 10-5 |
|---|---|
| Maximum | 0.999947 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 1.1 × 10-5 |
|---|---|
| 5-th percentile | 0.009007 |
| Q1 | 0.32525725 |
| median | 0.6 |
| Q3 | 0.85087275 |
| 95-th percentile | 0.98535265 |
| Maximum | 0.999947 |
| Range | 0.999936 |
| Interquartile range (IQR) | 0.5256155 |
Descriptive statistics
| Standard deviation | 0.30784253 |
|---|---|
| Coefficient of variation (CV) | 0.54410064 |
| Kurtosis | -1.0598373 |
| Mean | 0.56578233 |
| Median Absolute Deviation (MAD) | 0.2616135 |
| Skewness | -0.2788888 |
| Sum | 605.38709 |
| Variance | 0.094767023 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.5 | 61 | 5.7% |
| 0.6 | 54 | 5.0% |
| 0.4 | 50 | 4.7% |
| 0.68 | 28 | 2.6% |
| 0.32 | 25 | 2.3% |
| 0.256 | 16 | 1.5% |
| 0.744 | 16 | 1.5% |
| 0.7952 | 15 | 1.4% |
| 0.2048 | 12 | 1.1% |
| 0.48 | 12 | 1.1% |
| Other values (543) | 781 |
| Value | Count | Frequency (%) |
| 1.1 × 10-5 | 1 | |
| 1.4 × 10-5 | 1 | |
| 1.7 × 10-5 | 1 | |
| 2.2 × 10-5 | 1 | |
| 2.7 × 10-5 | 1 | |
| 3.4 × 10-5 | 1 | |
| 4.3 × 10-5 | 1 | |
| 5.3 × 10-5 | 1 | |
| 6.6 × 10-5 | 1 | |
| 8.3 × 10-5 | 1 |
| Value | Count | Frequency (%) |
| 0.999947 | 1 | |
| 0.999934 | 1 | |
| 0.999917 | 1 | |
| 0.999896 | 1 | |
| 0.99987 | 1 | |
| 0.999838 | 1 | |
| 0.999797 | 1 | |
| 0.999746 | 1 | |
| 0.999683 | 1 | |
| 0.999604 | 1 |
SalePriceMM
Real number (ℝ)
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9620467 |
| Minimum | 1.19 |
|---|---|
| Maximum | 2.29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 1.19 |
|---|---|
| 5-th percentile | 1.5305 |
| Q1 | 1.69 |
| median | 2.09 |
| Q3 | 2.13 |
| 95-th percentile | 2.23 |
| Maximum | 2.29 |
| Range | 1.1 |
| Interquartile range (IQR) | 0.44 |
Descriptive statistics
| Standard deviation | 0.25269736 |
|---|---|
| Coefficient of variation (CV) | 0.12879273 |
| Kurtosis | -0.51861837 |
| Mean | 1.9620467 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | -0.79716439 |
| Sum | 2099.39 |
| Variance | 0.063855957 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.09 | 209 | |
| 2.18 | 144 | |
| 1.69 | 127 | |
| 2.13 | 127 | |
| 1.59 | 101 | |
| 2.23 | 88 | |
| 1.99 | 66 | 6.2% |
| 1.89 | 44 | 4.1% |
| 1.79 | 44 | 4.1% |
| 2.29 | 33 | 3.1% |
| Other values (8) | 87 |
| Value | Count | Frequency (%) |
| 1.19 | 7 | 0.7% |
| 1.38 | 19 | 1.8% |
| 1.39 | 10 | 0.9% |
| 1.48 | 5 | 0.5% |
| 1.49 | 13 | 1.2% |
| 1.58 | 6 | 0.6% |
| 1.59 | 101 | |
| 1.69 | 127 | |
| 1.78 | 12 | 1.1% |
| 1.79 | 44 | 4.1% |
| Value | Count | Frequency (%) |
| 2.29 | 33 | 3.1% |
| 2.23 | 88 | |
| 2.18 | 144 | |
| 2.13 | 127 | |
| 2.12 | 15 | 1.4% |
| 2.09 | 209 | |
| 1.99 | 66 | 6.2% |
| 1.89 | 44 | 4.1% |
| 1.79 | 44 | 4.1% |
| 1.78 | 12 | 1.1% |
SalePriceCH
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8155607 |
| Minimum | 1.39 |
|---|---|
| Maximum | 2.09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 1.39 |
|---|---|
| 5-th percentile | 1.49 |
| Q1 | 1.75 |
| median | 1.86 |
| Q3 | 1.89 |
| 95-th percentile | 1.99 |
| Maximum | 2.09 |
| Range | 0.7 |
| Interquartile range (IQR) | 0.14 |
Descriptive statistics
| Standard deviation | 0.14338359 |
|---|---|
| Coefficient of variation (CV) | 0.078974821 |
| Kurtosis | 0.95978822 |
| Mean | 1.8155607 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | -0.95265054 |
| Sum | 1942.65 |
| Variance | 0.020558853 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.86 | 273 | |
| 1.99 | 183 | |
| 1.89 | 101 | 9.4% |
| 1.79 | 101 | 9.4% |
| 1.75 | 95 | 8.9% |
| 1.69 | 90 | 8.4% |
| 1.76 | 76 | 7.1% |
| 1.49 | 48 | 4.5% |
| 1.59 | 34 | 3.2% |
| 1.96 | 29 | 2.7% |
| Other values (3) | 40 | 3.7% |
| Value | Count | Frequency (%) |
| 1.39 | 27 | 2.5% |
| 1.49 | 48 | 4.5% |
| 1.59 | 34 | 3.2% |
| 1.69 | 90 | 8.4% |
| 1.75 | 95 | 8.9% |
| 1.76 | 76 | 7.1% |
| 1.79 | 101 | 9.4% |
| 1.86 | 273 | |
| 1.89 | 101 | 9.4% |
| 1.96 | 29 | 2.7% |
| Value | Count | Frequency (%) |
| 2.09 | 6 | 0.6% |
| 2.06 | 7 | 0.7% |
| 1.99 | 183 | |
| 1.96 | 29 | 2.7% |
| 1.89 | 101 | 9.4% |
| 1.86 | 273 | |
| 1.79 | 101 | 9.4% |
| 1.76 | 76 | 7.1% |
| 1.75 | 95 | 8.9% |
| 1.69 | 90 | 8.4% |
| Distinct | 36 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14648598 |
| Minimum | -0.67 |
|---|---|
| Maximum | 0.64 |
| Zeros | 75 |
| Zeros (%) | 7.0% |
| Negative | 239 |
| Negative (%) | 22.3% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | -0.67 |
|---|---|
| 5-th percentile | -0.4 |
| Q1 | 0 |
| median | 0.23 |
| Q3 | 0.32 |
| 95-th percentile | 0.54 |
| Maximum | 0.64 |
| Range | 1.31 |
| Interquartile range (IQR) | 0.32 |
Descriptive statistics
| Standard deviation | 0.27156269 |
|---|---|
| Coefficient of variation (CV) | 1.8538476 |
| Kurtosis | 0.46593925 |
| Mean | 0.14648598 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | -0.75977786 |
| Sum | 156.74 |
| Variance | 0.073746293 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.3 | 112 | 10.5% |
| 0.32 | 111 | 10.4% |
| 0.2 | 96 | 9.0% |
| 0.24 | 94 | 8.8% |
| 0 | 75 | 7.0% |
| 0.64 | 48 | 4.5% |
| -0.16 | 46 | 4.3% |
| 0.03 | 40 | 3.7% |
| 0.33 | 37 | 3.5% |
| -0.2 | 37 | 3.5% |
| Other values (26) | 374 |
| Value | Count | Frequency (%) |
| -0.67 | 7 | 0.7% |
| -0.58 | 19 | |
| -0.57 | 10 | 0.9% |
| -0.4 | 24 | |
| -0.38 | 5 | 0.5% |
| -0.3 | 22 | |
| -0.28 | 6 | 0.6% |
| -0.27 | 3 | 0.3% |
| -0.2 | 37 | |
| -0.17 | 19 |
| Value | Count | Frequency (%) |
| 0.64 | 48 | |
| 0.54 | 29 | 2.7% |
| 0.44 | 24 | 2.2% |
| 0.42 | 20 | 1.9% |
| 0.4 | 2 | 0.2% |
| 0.38 | 5 | 0.5% |
| 0.33 | 37 | 3.5% |
| 0.32 | 111 | |
| 0.3 | 112 | |
| 0.27 | 36 | 3.4% |
Store7
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 714 | |
| True | 356 |
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.059298436 |
| Minimum | 0 |
|---|---|
| Maximum | 0.40201 |
| Zeros | 746 |
| Zeros (%) | 69.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.112676 |
| 95-th percentile | 0.253521 |
| Maximum | 0.40201 |
| Range | 0.40201 |
| Interquartile range (IQR) | 0.112676 |
Descriptive statistics
| Standard deviation | 0.10176004 |
|---|---|
| Coefficient of variation (CV) | 1.7160662 |
| Kurtosis | 1.2725805 |
| Mean | 0.059298436 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.5394911 |
| Sum | 63.449326 |
| Variance | 0.010355106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 746 | |
| 0.201005 | 59 | 5.5% |
| 0.191388 | 54 | 5.0% |
| 0.253521 | 42 | 3.9% |
| 0.150754 | 29 | 2.7% |
| 0.366972 | 19 | 1.8% |
| 0.112676 | 18 | 1.7% |
| 0.027523 | 15 | 1.4% |
| 0.118343 | 13 | 1.2% |
| 0.183486 | 12 | 1.1% |
| Other values (8) | 63 | 5.9% |
| Value | Count | Frequency (%) |
| 0 | 746 | |
| 0.027523 | 15 | 1.4% |
| 0.050251 | 9 | 0.8% |
| 0.095694 | 10 | 0.9% |
| 0.100503 | 9 | 0.8% |
| 0.112676 | 18 | 1.7% |
| 0.118343 | 13 | 1.2% |
| 0.150754 | 29 | 2.7% |
| 0.174672 | 7 | 0.7% |
| 0.183486 | 12 | 1.1% |
| Value | Count | Frequency (%) |
| 0.40201 | 7 | 0.7% |
| 0.366972 | 19 | 1.8% |
| 0.347418 | 10 | 0.9% |
| 0.321101 | 5 | 0.5% |
| 0.275229 | 6 | 0.6% |
| 0.253521 | 42 | |
| 0.201005 | 59 | |
| 0.191388 | 54 | |
| 0.183486 | 12 | 1.1% |
| 0.174672 | 7 | 0.7% |
| Distinct | 13 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.027313837 |
| Minimum | 0 |
|---|---|
| Maximum | 0.252688 |
| Zeros | 838 |
| Zeros (%) | 78.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.198925 |
| Maximum | 0.252688 |
| Range | 0.252688 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.062232404 |
|---|---|
| Coefficient of variation (CV) | 2.2784204 |
| Kurtosis | 4.8776958 |
| Mean | 0.027313837 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.4223001 |
| Sum | 29.225806 |
| Variance | 0.0038728721 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 838 | |
| 0.050251 | 59 | 5.5% |
| 0.198925 | 36 | 3.4% |
| 0.145161 | 29 | 2.7% |
| 0.252688 | 21 | 2.0% |
| 0.095694 | 21 | 2.0% |
| 0.068783 | 21 | 2.0% |
| 0.053763 | 15 | 1.4% |
| 0.251256 | 12 | 1.1% |
| 0.177515 | 6 | 0.6% |
| Other values (3) | 12 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 838 | |
| 0.050251 | 59 | 5.5% |
| 0.053763 | 15 | 1.4% |
| 0.068783 | 21 | 2.0% |
| 0.091398 | 2 | 0.2% |
| 0.091429 | 5 | 0.5% |
| 0.095694 | 21 | 2.0% |
| 0.120603 | 5 | 0.5% |
| 0.145161 | 29 | 2.7% |
| 0.177515 | 6 | 0.6% |
| Value | Count | Frequency (%) |
| 0.252688 | 21 | |
| 0.251256 | 12 | 1.1% |
| 0.198925 | 36 | |
| 0.177515 | 6 | 0.6% |
| 0.145161 | 29 | |
| 0.120603 | 5 | 0.5% |
| 0.095694 | 21 | |
| 0.091429 | 5 | 0.5% |
| 0.091398 | 2 | 0.2% |
| 0.068783 | 21 |
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.21799065 |
| Minimum | 0 |
|---|---|
| Maximum | 0.44 |
| Zeros | 119 |
| Zeros (%) | 11.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.14 |
| median | 0.24 |
| Q3 | 0.3 |
| 95-th percentile | 0.32 |
| Maximum | 0.44 |
| Range | 0.44 |
| Interquartile range (IQR) | 0.16 |
Descriptive statistics
| Standard deviation | 0.10753545 |
|---|---|
| Coefficient of variation (CV) | 0.49330302 |
| Kurtosis | -0.22899269 |
| Mean | 0.21799065 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | -0.64520812 |
| Sum | 233.25 |
| Variance | 0.011563873 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.24 | 159 | |
| 0.32 | 149 | |
| 0.27 | 143 | |
| 0 | 119 | |
| 0.3 | 119 | |
| 0.1 | 105 | |
| 0.23 | 75 | |
| 0.14 | 37 | 3.5% |
| 0.2 | 32 | 3.0% |
| 0.13 | 28 | 2.6% |
| Other values (8) | 104 |
| Value | Count | Frequency (%) |
| 0 | 119 | |
| 0.07 | 7 | 0.7% |
| 0.1 | 105 | |
| 0.13 | 28 | 2.6% |
| 0.14 | 37 | 3.5% |
| 0.17 | 10 | 0.9% |
| 0.19 | 13 | 1.2% |
| 0.2 | 32 | 3.0% |
| 0.22 | 19 | 1.8% |
| 0.23 | 75 |
| Value | Count | Frequency (%) |
| 0.44 | 24 | 2.2% |
| 0.42 | 10 | 0.9% |
| 0.33 | 11 | 1.0% |
| 0.32 | 149 | |
| 0.3 | 119 | |
| 0.29 | 10 | 0.9% |
| 0.27 | 143 | |
| 0.24 | 159 | |
| 0.23 | 75 | |
| 0.22 | 19 | 1.8% |
STORE
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 KiB |
| 0 | |
|---|---|
| 2 | |
| 3 | |
| 1 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1070 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1070 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1070 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1070 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 2 | 222 | |
| 3 | 196 | |
| 1 | 157 | |
| 4 | 139 | 13.0% |
Auto
The auto setting is an interpretable pairwise column metric of the following mapping:- Variable_type-Variable_type : Method, Range
- Categorical-Categorical : Cramer's V, [0,1]
- Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
- Numerical-Numerical : Spearman's ρ, [-1,1]
This configuration uses the recommended metric for each pair of columns.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.| Id | Purchase | WeekofPurchase | StoreID | PriceCH | PriceMM | DiscCH | DiscMM | SpecialCH | SpecialMM | LoyalCH | SalePriceMM | SalePriceCH | PriceDiff | Store7 | PctDiscMM | PctDiscCH | ListPriceDiff | STORE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | CH | 237 | 1 | 1.75 | 1.99 | 0.00 | 0.0 | 0 | 0 | 0.500000 | 1.99 | 1.75 | 0.24 | No | 0.000000 | 0.000000 | 0.24 | 1 |
| 1 | 2 | CH | 239 | 1 | 1.75 | 1.99 | 0.00 | 0.3 | 0 | 1 | 0.600000 | 1.69 | 1.75 | -0.06 | No | 0.150754 | 0.000000 | 0.24 | 1 |
| 2 | 3 | CH | 245 | 1 | 1.86 | 2.09 | 0.17 | 0.0 | 0 | 0 | 0.680000 | 2.09 | 1.69 | 0.40 | No | 0.000000 | 0.091398 | 0.23 | 1 |
| 3 | 4 | MM | 227 | 1 | 1.69 | 1.69 | 0.00 | 0.0 | 0 | 0 | 0.400000 | 1.69 | 1.69 | 0.00 | No | 0.000000 | 0.000000 | 0.00 | 1 |
| 4 | 5 | CH | 228 | 7 | 1.69 | 1.69 | 0.00 | 0.0 | 0 | 0 | 0.956535 | 1.69 | 1.69 | 0.00 | Yes | 0.000000 | 0.000000 | 0.00 | 0 |
| 5 | 6 | CH | 230 | 7 | 1.69 | 1.99 | 0.00 | 0.0 | 0 | 1 | 0.965228 | 1.99 | 1.69 | 0.30 | Yes | 0.000000 | 0.000000 | 0.30 | 0 |
| 6 | 7 | CH | 232 | 7 | 1.69 | 1.99 | 0.00 | 0.4 | 1 | 1 | 0.972182 | 1.59 | 1.69 | -0.10 | Yes | 0.201005 | 0.000000 | 0.30 | 0 |
| 7 | 8 | CH | 234 | 7 | 1.75 | 1.99 | 0.00 | 0.4 | 1 | 0 | 0.977746 | 1.59 | 1.75 | -0.16 | Yes | 0.201005 | 0.000000 | 0.24 | 0 |
| 8 | 9 | CH | 235 | 7 | 1.75 | 1.99 | 0.00 | 0.4 | 0 | 0 | 0.982197 | 1.59 | 1.75 | -0.16 | Yes | 0.201005 | 0.000000 | 0.24 | 0 |
| 9 | 10 | CH | 238 | 7 | 1.75 | 1.99 | 0.00 | 0.4 | 0 | 0 | 0.985757 | 1.59 | 1.75 | -0.16 | Yes | 0.201005 | 0.000000 | 0.24 | 0 |
| Id | Purchase | WeekofPurchase | StoreID | PriceCH | PriceMM | DiscCH | DiscMM | SpecialCH | SpecialMM | LoyalCH | SalePriceMM | SalePriceCH | PriceDiff | Store7 | PctDiscMM | PctDiscCH | ListPriceDiff | STORE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1060 | 1061 | MM | 236 | 1 | 1.75 | 1.99 | 0.0 | 0.00 | 0 | 0 | 0.695258 | 1.99 | 1.75 | 0.24 | No | 0.000000 | 0.000000 | 0.24 | 1 |
| 1061 | 1062 | MM | 242 | 1 | 1.86 | 1.99 | 0.0 | 0.30 | 0 | 1 | 0.556206 | 1.69 | 1.86 | -0.17 | No | 0.150754 | 0.000000 | 0.13 | 1 |
| 1062 | 1063 | MM | 245 | 7 | 1.86 | 2.09 | 0.0 | 0.20 | 0 | 0 | 0.444965 | 1.89 | 1.86 | 0.03 | Yes | 0.095694 | 0.000000 | 0.23 | 0 |
| 1063 | 1064 | CH | 251 | 1 | 1.76 | 2.09 | 0.0 | 0.00 | 0 | 0 | 0.355972 | 2.09 | 1.76 | 0.33 | No | 0.000000 | 0.000000 | 0.33 | 1 |
| 1064 | 1065 | CH | 251 | 7 | 1.86 | 2.09 | 0.1 | 0.00 | 0 | 0 | 0.484778 | 2.09 | 1.76 | 0.33 | Yes | 0.000000 | 0.053763 | 0.23 | 0 |
| 1065 | 1066 | CH | 252 | 7 | 1.86 | 2.09 | 0.1 | 0.00 | 0 | 0 | 0.587822 | 2.09 | 1.76 | 0.33 | Yes | 0.000000 | 0.053763 | 0.23 | 0 |
| 1066 | 1067 | CH | 256 | 7 | 1.86 | 2.18 | 0.0 | 0.00 | 0 | 0 | 0.670258 | 2.18 | 1.86 | 0.32 | Yes | 0.000000 | 0.000000 | 0.32 | 0 |
| 1067 | 1068 | MM | 257 | 7 | 1.86 | 2.18 | 0.0 | 0.00 | 0 | 0 | 0.736206 | 2.18 | 1.86 | 0.32 | Yes | 0.000000 | 0.000000 | 0.32 | 0 |
| 1068 | 1069 | CH | 261 | 7 | 1.86 | 2.13 | 0.0 | 0.24 | 0 | 0 | 0.588965 | 1.89 | 1.86 | 0.03 | Yes | 0.112676 | 0.000000 | 0.27 | 0 |
| 1069 | 1070 | CH | 270 | 1 | 1.86 | 2.18 | 0.0 | 0.00 | 0 | 0 | 0.671172 | 2.18 | 1.86 | 0.32 | No | 0.000000 | 0.000000 | 0.32 | 1 |